CREATE TABLE [dbo].[Tb_FuncionamientoyServicios]
(
[idFuncionamientoyServicios] [int] NOT NULL IDENTITY(1, 1),
[Biblioteca] [int] NULL,
[FrenteEspopular] [int] NULL,
[ExponeHorario] [int] NULL,
[HorarioDesde] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[HorarioHasta] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[DiasAtencionPublico] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[HorasSemanalesAtencion] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[AtencionPublico] [int] NULL,
[SalaSilenciosa] [int] NULL,
[SalaInfantil] [int] NULL,
[Referencia] [int] NULL,
[LibrosEnSala] [int] NULL,
[SalonUM] [int] NULL,
[OtrasSalas] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[Tb_FuncionamientoyServicios] ADD CONSTRAINT [PK_Tb_FuncionamientoyServicios] PRIMARY KEY CLUSTERED  ([idFuncionamientoyServicios]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[Tb_FuncionamientoyServicios] WITH NOCHECK ADD CONSTRAINT [FK_Tb_FuncionamientoyServicios_tb_SiNo2] FOREIGN KEY ([AtencionPublico]) REFERENCES [dbo].[tb_SiNo] ([Id])
GO
ALTER TABLE [dbo].[Tb_FuncionamientoyServicios] WITH NOCHECK ADD CONSTRAINT [FK_Tb_FuncionamientoyServicios_Tb_Biliotecas] FOREIGN KEY ([Biblioteca]) REFERENCES [dbo].[Tb_Biliotecas] ([idbiblioteca]) NOT FOR REPLICATION
GO
ALTER TABLE [dbo].[Tb_FuncionamientoyServicios] WITH NOCHECK ADD CONSTRAINT [FK_Tb_FuncionamientoyServicios_tb_SiNo1] FOREIGN KEY ([ExponeHorario]) REFERENCES [dbo].[tb_SiNo] ([Id])
GO
ALTER TABLE [dbo].[Tb_FuncionamientoyServicios] WITH NOCHECK ADD CONSTRAINT [FK_Tb_FuncionamientoyServicios_tb_SiNo] FOREIGN KEY ([FrenteEspopular]) REFERENCES [dbo].[tb_SiNo] ([Id])
GO
ALTER TABLE [dbo].[Tb_FuncionamientoyServicios] WITH NOCHECK ADD CONSTRAINT [FK_Tb_FuncionamientoyServicios_tb_SiNo6] FOREIGN KEY ([LibrosEnSala]) REFERENCES [dbo].[tb_SiNo] ([Id])
GO
ALTER TABLE [dbo].[Tb_FuncionamientoyServicios] WITH NOCHECK ADD CONSTRAINT [FK_Tb_FuncionamientoyServicios_tb_SiNo5] FOREIGN KEY ([Referencia]) REFERENCES [dbo].[tb_SiNo] ([Id])
GO
ALTER TABLE [dbo].[Tb_FuncionamientoyServicios] WITH NOCHECK ADD CONSTRAINT [FK_Tb_FuncionamientoyServicios_tb_SiNo4] FOREIGN KEY ([SalaInfantil]) REFERENCES [dbo].[tb_SiNo] ([Id])
GO
ALTER TABLE [dbo].[Tb_FuncionamientoyServicios] WITH NOCHECK ADD CONSTRAINT [FK_Tb_FuncionamientoyServicios_tb_SiNo3] FOREIGN KEY ([SalaSilenciosa]) REFERENCES [dbo].[tb_SiNo] ([Id])
GO
ALTER TABLE [dbo].[Tb_FuncionamientoyServicios] WITH NOCHECK ADD CONSTRAINT [FK_Tb_FuncionamientoyServicios_tb_SiNo7] FOREIGN KEY ([SalonUM]) REFERENCES [dbo].[tb_SiNo] ([Id])
GO
ALTER TABLE [dbo].[Tb_FuncionamientoyServicios] NOCHECK CONSTRAINT [FK_Tb_FuncionamientoyServicios_Tb_Biliotecas]
GO
